2015-06-26- 17350.300 - Spec - Change Extract for Edicom (Beatriz Arribas by 2015-06-26) #ABAPEXTRACT #invoices #Mexico
SPECIFICATIONS
17350.300-Spec- Change Extract for Edicom
Purpose
To get the Cust ID from JM (Mark for Store) partner for specific customer in case of non consolidation of invoice.
Admin Info
Purpose
|
To get the Cust ID from JM (Mark for Store) partner for specific customer in case of non consolidation of invoice.
|
Requested By
|
Beatriz Arribas
|
Spec Created By
|
Deepak Yasam
|
Spec Created Date
|
06/26/2015
|
Spec QA by
|
Deepak Yasam
|
Objects
|
ZISD_ETI_INVOICE_EXTRACT
|
Document Status
|
WIP
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
00
|
2
|
Documentation
|
02
|
3
|
Development/ Config
|
10
|
4
|
Unit test in DEV
|
04
|
5
|
Unit test in QUA
|
|
6
|
Other activity
|
|
|
TOTAL
|
16
|
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]
Documents
[Attach any document(s) received for the requirement(s)]
Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
Sl.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]
For specific Mexico Customer the Cust ID needs to be pulled from JM partner other than from SH that is considered for other customers.
In Scope:
[List the
activities to be included in scope]
This change is limited to Specific customer and for non consolidated invoice.The consolidated invoice ,credit and debit memos of this specifc customer will still have the old logic of getting it from SH.
Out of Scope:
[Out of scope activities]
Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
1.A new variable should be created in TVARVC table and the specific customer is maintained in it.
2.The logic needs to be changed to get the JM partner Cust ID for the above customer and for single SO ie., non consolidated invoice scenario.
3.For consolidated invoice and other billing documents such as credit memo,debit memo,return credit memo,ZPTO invoice,ZU3P invoice will have the cust ID from SH partner . This is same as the existing logic that works for other Mexico customers.
Test Plan
[List test scenarios/cases to be executed here]
For TVARVC Sold to :
S.No
|
Test Scenario
|
Expected Result
|
SD001
|
1.Create a ZOR SO in 1500,10,00 sales area with TVARVC maintained Sold to and JM partner 2.Create corresponding delivery and invoice. 3.Issue ZETI output in the invoice.
|
The ETI invoice extract file should have the Cust partner ID of JM partner of the ZOR sales order.
|
SD002
|
1.Create a ZRE SO in 1500,10,00 sales area with TVARVC maintained Sold to and JM partner 2.Create corresponding delivery and invoice. 3.Issue ZETI output in the invoice.
|
The ETI invoice extract file should have the Cust partner ID of Ship to partner(from VBAK) of the ZRE document.
|
SD003
|
1.Create a ZCR SO in 1500,10,00 sales area with TVARVC maintained Sold to and JM partner 2.Create corresponding credit memo and Issue ZETI output in the credit memo.
|
The ETI invoice extract file should have the Cust partner ID of Ship to partner(from VBAK) of the ZCR document.
|
SD004
|
1.Create a ZDR SO in 1500,10,00 sales area with TVARVC maintained Sold to and JM partner 2.Create corresponding Debit memo and Issue ZETI output in the debit memo.
|
The ETI invoice extract file should have the Cust partner ID of Ship to partner(from VBAK) of the ZDR document.
|
SD005
|
1.Create a ZPTO SO in 1500,10,00 sales area with TVARVC maintained Sold to and JM partner 2.Create corresponding delivery and invoice. 3.Issue ZETI output in the invoice.
|
The ETI invoice extract file should have the Cust partner ID of Ship to partner(from VBAK) of the ZPTO document.
|
SD006
|
1.Create a ZU3P SO in 1500,10,00 sales area with TVARVC maintained Sold to and JM partner 2.Create corresponding delivery and invoice. 3.Issue ZETI output in the invoice.
|
The ETI invoice extract file should have the Cust partner ID of Ship to partner(from VBAK) of the ZU3P document.
|
SD007
|
1.Create a ZCR SO in 1500,10,00 sales area with TVARVC maintained Sold to and JM partner . This should be created with reference to invoice. 2.Create corresponding credit memo and Issue ZETI output in the credit memo.
|
The ETI invoice extract file should have the Cust partner ID as blank as the Cust ID value is blank (from VBAK) of the ZCR document.
|
SD008
|
1.Create a ZDR SO in 1500,10,00 sales area with TVARVC maintained Sold to and JM partner . This should be created with reference to invoice. 2.Create corresponding credit memo and Issue ZETI output in the debit memo.
|
The ETI invoice extract file should have the Cust partner ID as blank as the Cust ID value is blank (from VBAK) of the ZDR document.
|
SD009
|
1.Create multiple ZOR SO's in 1500,10,00 sales area with TVARVC maintained Sold to and with same JM partner in both the SO's. 2.Create corresponding deliveries and consolidated invoice. 3.Issue ZETI output in the consolidated invoice.
|
The ETI invoice extract file should have the Cust partner ID of of Ship to partner(from VBAK) of the ZOR sales order.
|
SD010
|
1.Create multiple ZOR SO's in 1500,10,00 sales area with TVARVC maintained Sold to and with different JM partner in both the SO's. 2.Create corresponding deliveries and consolidated invoice. 3.Issue ZETI output in the consolidated invoice.
|
The ETI invoice extract file should have the Cust partner ID ofof Ship to partner(from VBAK) of the first ZOR sales order.
|
SD011
|
Create a credit memo request ZCR in 1500,10,00 sales area with TVARVC maintained Sold to and with different JM partner with the reference of consolidated invoice. 2.Create corresponding credit memo .
|
The ETI invoice extract file should have the Cust partner ID as blank as the Cust ID value is blank (from VBAK) of the ZCR document.
|
SD012
|
Create a debit memo request ZCR in 1500,10,00 sales area with TVARVC maintained Sold to and with different JM partner with the reference of consolidated invoice. 2.Create corresponding debit memo .
|
The ETI invoice extract file should have the Cust partner ID as blank as the Cust ID value is blank (from VBAK) of the ZDR document.
|
For Non TVARVC Sold to :
S.No
|
Test Scenario
|
Expected Result
|
SD001
|
1.Create a ZOR SO in 1500,10,00 sales area with non TVARVC maintained Sold to and JM partner 2.Create corresponding delivery and invoice. 3.Issue ZETI output in the invoice.
|
The ETI invoice extract file should have the Cust partner ID of Ship to partner(from VBAK) of the ZOR sales order.
|
SD002
|
1.Create a ZRE SO in 1500,10,00 sales area with non TVARVC maintained Sold to and JM partner 2.Create corresponding delivery and invoice. 3.Issue ZETI output in the invoice.
|
The ETI invoice extract file should have the Cust partner ID of Ship to partner(from VBAK) of the ZRE document.
|
SD003
|
1.Create a ZCR SO in 1500,10,00 sales area with non TVARVC maintained Sold to and JM partner 2.Create corresponding credit memo and Issue ZETI output in the credit memo.
|
The ETI invoice extract file should have the Cust partner ID of Ship to partner(from VBAK) of the ZCR document.
|
SD004
|
1.Create a ZDR SO in 1500,10,00 sales area with non TVARVC maintained Sold to and JM partner 2.Create corresponding Debit memo and Issue ZETI output in the debit memo.
|
The ETI invoice extract file should have the Cust partner ID of Ship to partner(from VBAK) of the ZDR document.
|
SD005
|
1.Create a ZPTO SO in 1500,10,00 sales area with TVARVC maintained Sold to and JM partner 2.Create corresponding delivery and invoice. 3.Issue ZETI output in the invoice.
|
The ETI invoice extract file should have the Cust partner ID of Ship to partner(from VBAK) of the ZPTO document.
|
SD006
|
1.Create a ZU3P SO in 1500,10,00 sales area with TVARVC maintained Sold to and JM partner 2.Create corresponding delivery and invoice. 3.Issue ZETI output in the invoice.
|
The ETI invoice extract file should have the Cust partner ID of Ship to partner(from VBAK) of the ZU3P document.
|
SD007
|
1.Create a ZCR SO in 1500,10,00 sales area with non TVARVC maintained Sold to and JM partner . This should be created with reference to invoice. 2.Create corresponding credit memo and Issue ZETI output in the credit memo.
|
The ETI invoice extract file should have the Cust partner ID as blank as the Cust ID value is blank (from VBAK) of the ZCR document.
|
SD008
|
1.Create a ZDR SO in 1500,10,00 sales area with non TVARVC maintained Sold to and JM partner . This should be created with reference to invoice. 2.Create corresponding credit memo and Issue ZETI output in the debit memo.
|
The ETI invoice extract file should have the Cust partner ID as blank as the Cust ID value is blank (from VBAK) of the ZDR document.
|
SD009
|
1.Create multiple ZOR SO's in 1500,10,00 sales area with non TVARVC maintained Sold to and with same JM partner in both the SO's. 2.Create corresponding deliveries and consolidated invoice. 3.Issue ZETI output in the consolidated invoice.
|
The ETI invoice extract file should have the Cust partner ID of of Ship to partner(from VBAK) of the ZOR sales order.
|
SD010
|
1.Create multiple ZOR SO's in 1500,10,00 sales area with TVARVC maintained Sold to and with different JM partner in both the SO's. 2.Create corresponding deliveries and consolidated invoice. 3.Issue ZETI output in the consolidated invoice.
|
The ETI invoice extract file should have the Cust partner ID ofof Ship to partner(from VBAK) of the first ZOR sales order.
|
SD011
|
Create a credit memo request ZCR in 1500,10,00 sales area with non TVARVC maintained Sold to and with different JM partner with the reference of consolidated invoice. 2.Create corresponding credit memo .
|
The ETI invoice extract file should have the Cust partner ID as blank as the Cust ID value is blank (from VBAK) of the ZCR document.
|
SD012
|
Create a debit memo request ZCR in 1500,10,00 sales area with non TVARVC maintained Sold to and with different JM partner with the reference of consolidated invoice. 2.Create corresponding debit memo .
|
The ETI invoice extract file should have the Cust partner ID as blank as the Cust ID value is blank (from VBAK) of the ZDR document.
|
Solution Details
[Provide complete technical details for configuration or programming here]
A new TVARVC variable ZISD_ETI_INVOICE_EXTRACT_CUSID is added and the specific customer is maintained as desired.
Modified the Program for the documents which has Preceding document type as sales order and Non-Consolidated invoice.
- Added logic to check Document customer from TVARVC customer
- if both the customers are same, fetch 'JM' partner from VBPA table
- Fetch Identification of the Customer in the Partner System from KNA1 for 'JM' partner and pass it to the the extract output
Issues
[List Issues / Bugs identified in configuration or development]